
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ZICResponse]') AND type in (N'U'))
	DROP TABLE [dbo].[ZICResponse]
GO
CREATE TABLE [dbo].[ZICResponse](
	[ZICResponseID] INT CONSTRAINT pk_ZICResponse_Pid PRIMARY KEY identity,
	[ResponseCategory] [nvarchar](50) NULL,
	[ResponseResult] [nvarchar](50) NULL,
	[ResponseTime] datetime NULL,
	[AnchiID] int null
	)
go

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Branch]') AND type in (N'U'))
	DROP TABLE [dbo].[Branch]
GO
CREATE TABLE [dbo].[Branch](
	[BranchID] INT CONSTRAINT pk_Branch_Pid PRIMARY KEY identity,
	[Name] [nvarchar](100) NULL,
	[Remark] [nvarchar](50) NULL,
	[AnchiID] int null
	)
go

CREATE TABLE [dbo].[ContactResult]
(
	ContactResultID int constraint pk_contactresult_rid PRIMARY KEY identity,
	Result nVarchar(50)
); 
go

